CREATE TABLE `adgroup` (
  `id` int(11) NOT NULL,
  `groupname` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `ads` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `code_img` varchar(11) NOT NULL default '',
  `code` text NOT NULL,
  `imgurl` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `link_hits` varchar(255) NOT NULL default '',
  `groupname` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  `location` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `ads` VALUES (1, 'CCMS Ad', 'img', '', 'files/images/ccmsbanner.jpg', 'http://www.mygamingsite.com', '', '', '', 'Banner');

CREATE TABLE `article` (
  `id` int(10) NOT NULL auto_increment,
  `cat_id` varchar(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `type` varchar(100) NOT NULL default '',
  `content` text NOT NULL,
  `r_rating` varchar(100) NOT NULL default '',
  `views` int(11) NOT NULL default '0',
  `author` varchar(100) NOT NULL default '',
  `date` varchar(30) NOT NULL default '',
  `tag` varchar(55) NOT NULL default '',
  `game` varchar(250) NOT NULL default '',
  `featured` varchar(5) NOT NULL default '',
  `image` varchar(100) NOT NULL default '',
  `rating` decimal(2,1) NOT NULL default '0.0',
  `box` varchar(100) NOT NULL default '',
  `rating_1` decimal(2,1) NOT NULL default '0.0',
  `rating_2` decimal(2,1) NOT NULL default '0.0',
  `rating_3` decimal(2,1) NOT NULL default '0.0',
  `rating_4` decimal(2,1) NOT NULL default '0.0',
  `rating_5` decimal(2,1) NOT NULL default '0.0',
  `content2` text NOT NULL,
  `content3` text NOT NULL,
  `content4` text NOT NULL,
  `rating_1_text` varchar(255) NOT NULL default '',
  `rating_2_text` varchar(255) NOT NULL default '',
  `rating_3_text` varchar(255) NOT NULL default '',
  `rating_4_text` varchar(255) NOT NULL default '',
  `rating_5_text` varchar(255) NOT NULL default '',
  `rating_6` int(5) NOT NULL default '0',
  `rating_6_text` varchar(255) NOT NULL default '',
  `rating_overall` int(5) NOT NULL default '0',
  `rating_overall_text` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `article_comments` (
  `id` int(11) NOT NULL auto_increment,
  `w_id` varchar(11) NOT NULL default '',
  `name` varchar(55) NOT NULL default '',
  `comment` text NOT NULL,
  `ip` varchar(55) NOT NULL default '',
  `date` varchar(55) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `article_rate` (
  `id` smallint(10) unsigned NOT NULL default '0',
  `votes` int(10) unsigned NOT NULL default '0',
  `rating` smallint(2) unsigned NOT NULL default '0',
  `last_ip` char(16) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `article_submit` (
  `id` int(10) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `type` varchar(100) NOT NULL default '',
  `content` text NOT NULL,
  `r_rating` varchar(100) NOT NULL default '',
  `author` varchar(100) NOT NULL default '',
  `tag` varchar(55) NOT NULL default '',
  `submitted_by` varchar(55) NOT NULL default '',
  `game` varchar(10) NOT NULL default '',
  `rating_1` int(11) NOT NULL default '0',
  `rating_2` int(11) NOT NULL default '0',
  `rating_3` int(11) NOT NULL default '0',
  `rating_4` int(11) NOT NULL default '0',
  `rating_5` int(11) NOT NULL default '0',
  `rating_1_text` varchar(255) NOT NULL default '',
  `rating_2_text` varchar(255) NOT NULL default '',
  `rating_3_text` varchar(255) NOT NULL default '',
  `rating_4_text` varchar(255) NOT NULL default '',
  `rating_5_text` varchar(255) NOT NULL default '',
  `rating_6` int(5) NOT NULL default '0',
  `rating_6_text` varchar(255) NOT NULL default '',
  `rating_overall` int(5) NOT NULL default '0',
  `rating_overall_text` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `blog` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(55) NOT NULL default '',
  `date` varchar(55) NOT NULL default '',
  `content` text NOT NULL,
  `views` int(11) NOT NULL default '0',
  `author` varchar(55) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `blog_comments` (
  `id` int(11) NOT NULL auto_increment,
  `w_id` varchar(11) NOT NULL default '',
  `name` varchar(55) NOT NULL default '',
  `comment` text NOT NULL,
  `ip` varchar(55) NOT NULL default '',
  `date` varchar(55) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `cheat` (
  `id` int(11) NOT NULL auto_increment,
  `platform` varchar(11) NOT NULL default '',
  `game` varchar(100) NOT NULL default '',
  `cheats` text NOT NULL,
  `date` varchar(55) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `submitter` varchar(55) NOT NULL default '',
  `approved` int(15) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `collection` (
  `game` varchar(100) default '',
  `username` varchar(100) NOT NULL default '',
  `console` varchar(25) NOT NULL default ''
) TYPE=MyISAM;

CREATE TABLE `company` (
  `id` int(11) NOT NULL auto_increment,
  `compname` varchar(55) NOT NULL default '',
  `description` text NOT NULL,
  `website` varchar(55) NOT NULL default '',
  `country` varchar(255) NOT NULL default 'Blank',
  `address` varchar(255) NOT NULL default '',
  `phone` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `config` (
  `id` int(1) NOT NULL auto_increment,
  `font_large` varchar(55) NOT NULL default '',
  `skin` varchar(55) NOT NULL default '',
  `sitename` varchar(55) NOT NULL default '',
  `siteurl` varchar(100) NOT NULL default '',
  `email` varchar(55) NOT NULL default '',
  `newslimit` int(3) NOT NULL default '0',
  `shoutlimit` int(3) NOT NULL default '0',
  `avatar_width` int(10) NOT NULL default '0',
  `avatar_height` int(10) NOT NULL default '0',
  `postspp` int(10) NOT NULL default '0',
  `threadspp` int(10) NOT NULL default '0',
  `imagepath` varchar(50) NOT NULL default '',
  `header` text NOT NULL,
  `font` varchar(100) NOT NULL default '',
  `font_onlight1` varchar(25) NOT NULL default '',
  `font_onlight2` varchar(25) NOT NULL default '',
  `font_ondark1` varchar(25) NOT NULL default '',
  `font_ondark2` varchar(25) NOT NULL default '',
  `body` text NOT NULL,
  `form` text NOT NULL,
  `form_submit` text NOT NULL,
  `ct_width` varchar(5) NOT NULL default '',
  `shouts` int(11) NOT NULL default '0',
  `dlsetting` varchar(100) NOT NULL default '',
  `submitsys` varchar(55) NOT NULL default '',
  `show_featured` char(2) NOT NULL default 'Y',
  `newstype` varchar(20) NOT NULL default 'default',
  `time_an` varchar(255) NOT NULL default '',
  `time_s` varchar(255) NOT NULL default '',
  `time_c` varchar(255) NOT NULL default '',
  `time_f` varchar(255) NOT NULL default '',
  `font_bright_onlight` varchar(25) NOT NULL default '',
  `font_bright_ondark` varchar(25) NOT NULL default '',
  `tdreg` varchar(255) NOT NULL default '',
  `tablereg` varchar(255) NOT NULL default '',
  `tdreg2` varchar(255) NOT NULL default '',
  `ads` varchar(11) NOT NULL default 'no',
  `stats` varchar(11) NOT NULL default 'no',
  `nowplaying` varchar(11) NOT NULL default 'no',
  `form_textbox` varchar(255) NOT NULL default '',
  `form_dropdown1` varchar(255) NOT NULL default '',
  `form_dropdown2` varchar(255) NOT NULL default '',
  `font_onlight3` varchar(25) NOT NULL default '',
  `font_onlight4` varchar(25) NOT NULL default '',
  `table_bg1_light` varchar(100) NOT NULL default '',
  `table_bg2_light` varchar(100) NOT NULL default '',
  `tdreg3` varchar(255) NOT NULL default '',
  `font_onlight5` varchar(55) NOT NULL default '565656',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=1 AUTO_INCREMENT=2 ;

INSERT INTO `config` VALUES (1, '', 'default', 'CCMS v3.1 Demo PW', 'http://mygamingsite.com', 'user@none.com', 5, 5, 80, 70, 10, 15, 'images', '<head>\r\n<meta http-equiv="Content-Language" content="en-us">\r\n<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">\r\n<link rel="stylesheet" type="text/css" href="http://YOURSITE.COM/style.css" />\r\n\r\n<style fprolloverstyle>A:hover {color: #0077CC}</style>\r\n<style>\r\n    <!--\r\n    a{text-decoration:none}\r\n    //-->\r\n   </style>\r\n\r\n<style type="text/css">\r\nBODY {\r\n  scrollbar-arrow-color:000000;\r\n  scrollbar-face-color:BCBCBC;\r\n  scrollbar-highlight-color:F2F2F2;\r\n  scrollbar-darkshadow-color:BCBCBC;\r\n}\r\n</style>', '', '', '', '', '', '<body topmargin="0" leftmargin="0" link="#000000" vlink="#000000" alink="#000000" bgcolor="#565656" background="images/pagebg_1024.jpg">', 'font-size: 10px; color: #000000; font-family: Verdana; border: 1px solid #929292; height: 18px; padding: 2px;', 'font-size: 11px; color: #000000; font-family: Tahoma; font-weight: bold; weight: bold; font-color: #41D9FF; border: 1px solid #929292; background: #65DDFD url(images/bg_blue.jpg);', '', 1, 'Y', 'Y', 'Y', 'complex', 'd/m/Y', 'd/m/Y H:i', 'd/m/Y H:i', 'Y-m-d H:i:s', '', '', 'style="height: 20px; background: #FFFFFF url(images/td1.jpg) repeat-x;"', 'cellpadding=1 cellspacing=1 bgcolor=#B9B9B9 border=0', 'style="height: 20px; background: #F0F0F0 url(images/td2.jpg) repeat-x;"', 'Yes', 'No', 'No', 'padding: 2px; font-size: 10px; color: #000000; font-family: Verdana; background: #FFFFFF; border: 1px solid #929292', 'background-color: #E4FAFF;', 'background-color: #FFFFFF;', '', '', 'BEBEBE', 'EDEDED', 'style="height: 21px; background: #E4E4E4 url(images/bg_blue.jpg) repeat-x;"', '');

CREATE TABLE `file` (
  `id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `size` text NOT NULL,
  `creator` text NOT NULL,
  `dl_url` varchar(100) NOT NULL default '',
  `game` varchar(255) NOT NULL default '',
  `date` varchar(55) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `site` varchar(5) NOT NULL default '',
  `ss_url` varchar(255) NOT NULL default '',
  `ss2_url` varchar(255) NOT NULL default '',
  `video` varchar(55) NOT NULL default 'no',
  `vwidth` int(5) NOT NULL default '0',
  `vheight` int(5) NOT NULL default '0',
  `category` varchar(50) NOT NULL default '',
  `platform` varchar(10) NOT NULL default '',
  `featured` int(1) NOT NULL default '0',
  `image` varchar(55) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `file_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `category` varchar(55) NOT NULL default '',
  `description` text NOT NULL,
  `game` varchar(55) NOT NULL default '',
  `subcat` varchar(55) NOT NULL default 'no',
  `parent_id` varchar(5) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `file_comments` (
  `id` int(11) NOT NULL auto_increment,
  `w_id` varchar(11) NOT NULL default '',
  `name` varchar(55) NOT NULL default '',
  `comment` text NOT NULL,
  `ip` varchar(55) NOT NULL default '',
  `date` varchar(55) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `file_rate` (
  `id` smallint(10) unsigned NOT NULL default '0',
  `votes` int(10) unsigned NOT NULL default '0',
  `rating` smallint(2) unsigned NOT NULL default '0',
  `last_ip` char(16) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `file_submit` (
  `id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `size` text NOT NULL,
  `creator` text NOT NULL,
  `dl_url` varchar(100) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `ss_url` varchar(255) NOT NULL default '',
  `ss2_url` varchar(255) NOT NULL default '',
  `submitted_by` varchar(255) NOT NULL default '',
  `video` varchar(55) NOT NULL default 'no',
  `vwidth` int(5) NOT NULL default '0',
  `vheight` int(5) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `forums_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `category` varchar(100) NOT NULL default '',
  `description` varchar(250) NOT NULL default '',
  `active` char(3) NOT NULL default 'yes',
  `forder` mediumint(11) default NULL,
  PRIMARY KEY  (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

INSERT INTO `forums_cat` VALUES (1, 'CCMS General', '', 'yes', 1);

CREATE TABLE `forums_forumlist` (
  `id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `forum` varchar(100) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `active` varchar(5) NOT NULL default 'yes',
  `forder` int(10) NOT NULL default '0',
  `subcat` varchar(5) NOT NULL default '',
  `parentid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

INSERT INTO `forums_forumlist` VALUES (1, 1, 'Custom CMS', 'Discuss CCMS in this forum.', 'yes', 1, '0', 0);

CREATE TABLE `forums_post` (
  `id` int(11) NOT NULL auto_increment,
  `tid` int(11) NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `title` varchar(100) NOT NULL default 'Message',
  `date` varchar(100) default NULL,
  `umessage` text NOT NULL,
  `ipaddress` varchar(100) NOT NULL default '',
  `fid` int(11) NOT NULL default '0',
  `notes` text NOT NULL,
  `stamp` varchar(55) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `forums_thread` (
  `id` int(11) NOT NULL auto_increment,
  `fid` varchar(11) NOT NULL default '',
  `date` varchar(100) default NULL,
  `starter` varchar(100) NOT NULL default '',
  `title` varchar(50) NOT NULL default '',
  `open` int(5) NOT NULL default '1',
  `postuserid` varchar(10) NOT NULL default '',
  `views` int(10) NOT NULL default '0',
  `sticky` int(5) NOT NULL default '0',
  `lastpost` varchar(100) NOT NULL default '',
  `stamp` varchar(55) NOT NULL default '0',
  `picon` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `game_rate` (
  `id` smallint(10) unsigned NOT NULL default '0',
  `votes` int(10) unsigned NOT NULL default '0',
  `rating` smallint(2) unsigned NOT NULL default '0',
  `last_ip` char(16) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `gameindex` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `category` varchar(55) NOT NULL default '',
  `description` text NOT NULL,
  `box` varchar(100) NOT NULL default '',
  `date` varchar(55) NOT NULL default '',
  `gamespecs` text NOT NULL,
  `views` int(10) NOT NULL default '0',
  `burl` varchar(100) NOT NULL default '',
  `rdate` int(11) NOT NULL default '0',
  `developer` varchar(55) NOT NULL default '',
  `publisher` varchar(55) NOT NULL default '',
  `esrb` varchar(55) NOT NULL default '',
  `price` varchar(55) NOT NULL default '',
  `genre` varchar(55) NOT NULL default '',
  `rank` int(11) NOT NULL default '0',
  `rating` decimal(2,1) NOT NULL default '0.0',
  `release_uk` varchar(255) NOT NULL default '',
  `release_jp` varchar(255) NOT NULL default '',
  `aka` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `homeblock` (
  `block` int(5) NOT NULL auto_increment,
  `title` varchar(55) NOT NULL default '',
  `image` varchar(100) NOT NULL default '',
  `link` varchar(100) NOT NULL default '',
  `console` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`block`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

INSERT INTO `homeblock` VALUES (1, 'Change me', 'images/featured/f1.jpg', 'http://mygamingsite.com', 'x360');
INSERT INTO `homeblock` VALUES (2, 'Change me', 'images/featured/f2.jpg', 'http://mygamingsite.com', 'wii');
INSERT INTO `homeblock` VALUES (3, 'Change me', 'images/featured/f1.jpg', 'http://mygamingsite.com', 'psp');
INSERT INTO `homeblock` VALUES (4, 'Change me', 'images/featured/f2.jpg', 'http://mygamingsite.com', 'ps3');

CREATE TABLE `lastvisit` (
  `ip` varchar(100) NOT NULL default '',
  `lastvisit` varchar(100) NOT NULL default '00000000000000',
  `id` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `link_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `category` varchar(55) NOT NULL default '',
  `description` text NOT NULL,
  `game` varchar(55) NOT NULL default '',
  `subcat` varchar(11) NOT NULL default '',
  `parent_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `links` (
  `id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `title` varchar(55) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `date` varchar(25) NOT NULL default '',
  `ip` varchar(100) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `submitted_by` varchar(55) NOT NULL default '',
  `approved` int(15) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


CREATE TABLE `media_rate` (
  `id` smallint(10) unsigned NOT NULL default '0',
  `votes` int(10) unsigned NOT NULL default '0',
  `rating` smallint(2) unsigned NOT NULL default '0',
  `last_ip` char(16) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;


CREATE TABLE `mygames` (
  `gid` int(11) NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `console` varchar(25) NOT NULL default ''
) TYPE=MyISAM;

CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment ,
  `title` varchar(250) NOT NULL default '',
  `prev_news` text NOT NULL,
  `news` text NOT NULL,
  `author` varchar(99) NOT NULL default '',
  `email` varchar(99) NOT NULL default '',
  `archive_month` varchar(99) NOT NULL default '',
  `source` varchar(99) NOT NULL default '',
  `source_text` varchar(99) NOT NULL default '',
  `date` varchar(99) NOT NULL default '',
  `views` int(11) NOT NULL default '0',
  `rating` decimal(2,1) NOT NULL default '0.0',
  `platform` varchar(250) NOT NULL default '',
  `game` varchar(250) NOT NULL default '',
  `featured` int(11) NOT NULL default '0',
  `image` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `tag` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=1 AUTO_INCREMENT=1 ;

CREATE TABLE `news_comments` (
  `id` int(11) NOT NULL auto_increment,
  `w_id` varchar(11) NOT NULL default '',
  `name` varchar(55) NOT NULL default '',
  `comment` text NOT NULL,
  `ip` varchar(55) NOT NULL default '',
  `date` varchar(55) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `news_rate` (
  `id` smallint(10) unsigned NOT NULL default '0',
  `votes` int(10) unsigned NOT NULL default '0',
  `rating` smallint(2) unsigned NOT NULL default '0',
  `last_ip` char(16) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `news_submit` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(55) NOT NULL default '',
  `author` varchar(55) NOT NULL default '',
  `preview` text NOT NULL,
  `news` text NOT NULL,
  `submitted_by` varchar(55) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `nowplaying` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `gameid` int(11) NOT NULL default '0',
  `console` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `nowplaying` VALUES (1, 'Advanced Warfighter', 'Watch the launch trailer now', 0, 'x360', 'files/flv/video.flv');

CREATE TABLE `page` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `views` int(11) NOT NULL default '0',
  `last_update` varchar(99) NOT NULL default '',
  `cat` varchar(99) NOT NULL default '',
  `content` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `platform` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(55) NOT NULL default '',
  `icon` varchar(55) NOT NULL default '',
  `skin` varchar(255) NOT NULL default 'default',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;

INSERT INTO `platform` VALUES (1, 'Playstation 2', 'ps2', 'default');
INSERT INTO `platform` VALUES (2, 'Sony Playstation Portable', 'psp', 'default');
INSERT INTO `platform` VALUES (3, 'XBox', 'xbox', 'default');
INSERT INTO `platform` VALUES (4, 'XBox 360', 'x360', 'default');
INSERT INTO `platform` VALUES (6, 'Gameboy', 'gb', 'default');
INSERT INTO `platform` VALUES (7, 'Gamecube', 'gc', 'default');
INSERT INTO `platform` VALUES (9, 'Computer Game', 'pc', 'default');
INSERT INTO `platform` VALUES (10, 'N-Gage', 'ng', 'default');
INSERT INTO `platform` VALUES (14, 'Nintendo DS', 'ds', 'default');
INSERT INTO `platform` VALUES (13, 'Playstation 3', 'ps3', 'default');
INSERT INTO `platform` VALUES (16, 'Nintendo WII', 'wii', 'default');
INSERT INTO `platform` VALUES (17, 'Gameboy Advance', 'gba', 'default');

CREATE TABLE `poll` (
  `id` int(11) NOT NULL auto_increment,
  `question` varchar(255) NOT NULL default '',
  `ans1` varchar(100) NOT NULL default '',
  `ans2` varchar(100) NOT NULL default '',
  `ans3` varchar(100) NOT NULL default '',
  `ans4` varchar(100) NOT NULL default '',
  `ans5` varchar(100) NOT NULL default '',
  `ans6` varchar(100) NOT NULL default '',
  `ans7` varchar(100) NOT NULL default '',
  `ans8` varchar(100) NOT NULL default '',
  `ans9` varchar(100) NOT NULL default '',
  `ans10` varchar(100) NOT NULL default '',
  `open` int(1) NOT NULL default '0',
  `newsid` int(11) NOT NULL default '0',
  `lastip` varchar(55) NOT NULL default '',
  `homepage` int(1) NOT NULL default '0',
  `v1` int(11) NOT NULL default '0',
  `v2` int(11) NOT NULL default '0',
  `v3` int(11) NOT NULL default '0',
  `v4` int(11) NOT NULL default '0',
  `v5` int(11) NOT NULL default '0',
  `v6` int(11) NOT NULL default '0',
  `v7` int(11) NOT NULL default '0',
  `v8` int(11) NOT NULL default '0',
  `v9` int(11) NOT NULL default '0',
  `v10` int(11) NOT NULL default '0',
  `votes` int(11) NOT NULL default '0',
  `date` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `poll` VALUES (1, 'Do you like this cms?', 'Yes', 'No', 'Whats a cms?', '', '', '', '', '', '', '', 1, 0, '00.00.00.00', 1, 66, 13, 8, 0, 0, 0, 0, 0, 0, 0, 89, '22/08/2006');

CREATE TABLE `poll_comments` (
  `id` int(11) NOT NULL auto_increment,
  `w_id` varchar(11) NOT NULL default '',
  `name` varchar(55) NOT NULL default '',
  `comment` text NOT NULL,
  `ip` varchar(55) NOT NULL default '',
  `date` varchar(55) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `privatemessage` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(75) NOT NULL default '',
  `rec` varchar(75) NOT NULL default '',
  `send` varchar(75) NOT NULL default '',
  `date` varchar(55) NOT NULL default '',
  `stamp` varchar(25) NOT NULL default '',
  `message` text NOT NULL,
  `status` varchar(11) NOT NULL default 'new',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `rating_cat` (
  `id` int(11) NOT NULL auto_increment,
  `rating1` varchar(255) NOT NULL default '',
  `rating2` varchar(255) NOT NULL default '',
  `rating3` varchar(255) NOT NULL default '',
  `rating4` varchar(255) NOT NULL default '',
  `rating5` varchar(255) NOT NULL default '',
  `rating6` varchar(255) NOT NULL default '',
  `rating_overall` varchar(255) NOT NULL default 'Overall',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `rating_cat` VALUES (1, 'Presentation', 'Graphics', 'Sound', 'Gameplay', 'Multiplayer', '', 'Overall');

CREATE TABLE `screen_rate` (
  `id` smallint(10) unsigned NOT NULL default '0',
  `votes` int(10) unsigned NOT NULL default '0',
  `rating` smallint(2) unsigned NOT NULL default '0',
  `last_ip` char(16) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

CREATE TABLE `screenshots` (
  `id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `game` varchar(55) NOT NULL default '',
  `date` varchar(55) NOT NULL default '',
  `views` int(11) NOT NULL default '0',
  `submitter` varchar(55) NOT NULL default '',
  `platform` varchar(10) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `screenshots_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `category` varchar(55) NOT NULL default '',
  `description` text NOT NULL,
  `game` varchar(55) NOT NULL default '',
  `subcat` varchar(55) NOT NULL default 'no',
  `parent_id` varchar(5) NOT NULL default '0',
  PRIMARY KEY  (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `screenshots_submit` (
  `id` int(11) NOT NULL auto_increment,
  `cat_id` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `submitted_by` varchar(100) NOT NULL default '',
  `game` varchar(255) NOT NULL default '',
  `platform` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;


CREATE TABLE `shoutbox` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(55) NOT NULL default '',
  `shout` varchar(255) NOT NULL default '',
  `ip` varchar(25) NOT NULL default '',
  `date` varchar(25) NOT NULL default '',
  `stamp` varchar(55) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=2 ;


INSERT INTO `shoutbox` VALUES (1, 'Admin', 'Another CCMS is born!', 'CCMS Heaven', '01/10/2006 00:00', '200610010000');

CREATE TABLE `skin` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(55) NOT NULL default '',
  `current` char(2) NOT NULL default '0',
  `selectable` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=1 AUTO_INCREMENT=2 ;

INSERT INTO `skin` VALUES (1, 'default', '1', 1);

CREATE TABLE `ss_comments` (
  `id` int(11) NOT NULL auto_increment,
  `w_id` varchar(11) NOT NULL default '',
  `name` varchar(55) NOT NULL default '',
  `comment` text NOT NULL,
  `ip` varchar(55) NOT NULL default '',
  `date` varchar(25) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `user` (
  `userid` int(25) NOT NULL auto_increment,
  `email_address` varchar(50) NOT NULL default '',
  `username` varchar(25) NOT NULL default '',
  `PASSWORD` varchar(255) NOT NULL default '',
  `user_level` varchar(11) NOT NULL default '2',
  `signup_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
  `country` varchar(50) NOT NULL default 'blank',
  `ip` varchar(50) NOT NULL default '',
  `homepage` varchar(50) NOT NULL default 'http://',
  `xfire` varchar(50) NOT NULL default '',
  `activated` enum('0','1') NOT NULL default '1',
  `session` varchar(255) NOT NULL default '',
  `avatar` varchar(100) NOT NULL default '',
  `signature` text NOT NULL,
  `icq` varchar(15) NOT NULL default '',
  `title` varchar(20) NOT NULL default 'Registered',
  `staff` char(1) NOT NULL default '0',
  `pub_email` char(3) NOT NULL default 'yes',
  `bday` varchar(50) NOT NULL default '',
  `pcstats` text NOT NULL,
  `aim` varchar(100) NOT NULL default '',
  `msn` varchar(100) NOT NULL default '',
  `yahoo` varchar(100) NOT NULL default '',
  `skin` varchar(255) NOT NULL default 'default',
  `posts` int(11) NOT NULL default '0',
  `llogin` varchar(25) NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) TYPE=MyISAM PACK_KEYS=0 COMMENT='Membership Information' AUTO_INCREMENT=2 ;

INSERT INTO `user` VALUES (1, 'admin@site.com', 'Admin', 'd0763edaa9d9bd2a9516280e9044d885', '6', '2005-07-07 22:29:44', '2006-10-02 14:02:27', 'Canada', '127.0.0.1', 'http://www.mygamingsite.com', '', '1', '4cfa959f0ea6853dc54062af79132ef5', '', '', '', 'Admin', '1', 'no', '', '', '', '', '', 'default', 0, '');

CREATE TABLE `user_level` (
  `level` int(5) NOT NULL auto_increment,
  `title` varchar(55) NOT NULL default '',
  `staff` int(1) NOT NULL default '0',
  `access` text NOT NULL,
  `access_news` int(15) NOT NULL default '0',
  `access_articles` int(15) NOT NULL default '0',
  `access_files` int(15) NOT NULL default '0',
  `access_games` int(15) NOT NULL default '0',
  `access_cheats` int(15) NOT NULL default '0',
  `access_users` int(15) NOT NULL default '0',
  `access_options` int(15) NOT NULL default '0',
  `access_media` int(15) NOT NULL default '0',
  `access_links` int(15) NOT NULL default '0',
  `access_forums` int(15) NOT NULL default '0',
  `access_shoutbox` int(15) NOT NULL default '0',
  `access_submit` int(15) NOT NULL default '0',
  `access_comments` int(15) NOT NULL default '0',
  `access_pm` int(15) NOT NULL default '0',
  `access_forumpost` int(15) NOT NULL default '0',
  `ads` int(2) NOT NULL default '1',
  PRIMARY KEY  (`level`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

INSERT INTO `user_level` VALUES (6, 'Admin', 1, '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `user_level` VALUES (1, 'User', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `user_level` VALUES (2, 'Member', 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1);

CREATE TABLE `useronline` (
  `timestamp` int(15) NOT NULL default '0',
  `ttime` varchar(55) NOT NULL default '',
  `username` varchar(55) NOT NULL default '',
  `ip` varchar(40) NOT NULL default '',
  `file` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`timestamp`),
  KEY `ip` (`ip`),
  KEY `file` (`file`)
) TYPE=MyISAM;

CREATE TABLE `wishlist` (
  `id` int(11) NOT NULL auto_increment,
  `game` varchar(55) NOT NULL default '',
  `username` varchar(55) NOT NULL default '',
  `console` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;